export const PermissionQueries = {
    GetPermissions: `
    SELECT
      id,
      permissionName,
      pid
    FROM my_schema.permission
    `,

    GetPermissionsByIds: `
    SELECT
      id,
      permissionName,
      pid
    FROM my_schema.permission
    WHERE
      id IN ?
    `,
  
    GetPermissionById: `
    SELECT
      id,
      permissionName,
      pid
    FROM my_schema.permission
    WHERE
      id = ?
    `,
  
    AddPermission: `
    INSERT INTO my_schema.permission (id, permissionName, pid)
      VALUES ?
    `,
  
    DeletePermissionById: `
    DELETE FROM my_schema.permission
    WHERE
      id = ?
    `
  };